package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class JDBCDemo11 {
    public static void main(String[] args) {
    try (Connection conn = DBUtil.getConnection()) {
        conn.setAutoCommit(false);//关闭主动提交
        String sql = "INSERT INTO userinfo(username,password,nickname,age) " +
                "VALUES(?,?,?,?)";
                PreparedStatement ps  = conn.prepareStatement(sql);
                ps.setString(1,"王族");
                ps.setString(2,"123456");
                ps.setString(3,"老王");
                ps.setInt(4,33);
                int num = ps.executeUpdate();
                System.out.println(num>0?"添加成功":"添加失败");
                conn.commit();
                System.out.println("添加成功了");
                /*conn.rollback();
                System.out.println("事务回滚了");*/
    } catch (Exception e) {
        throw new RuntimeException(e);
    }
    }
}
